HND SEC4205 Database Database Design and Development Assignment: Personal DVD Library

About this Report

The "HND SEC4205 Database Design and Development Assignment: Personal DVD Library" is a pivotal undertaking in the realm of Higher National Diploma (HND) studies, specifically for students enrolled in the SEC4205 course. This comprehensive assignment immerses students in the intricacies of database design and development, offering them a hands-on opportunity to construct a database tailored to a real-world scenario�a personal DVD library. The assignment commences with the creation of an Entity-Relationship (ER) diagram, serving as the foundational blueprint for the entire database design process. The crux of this assignment revolves around the ER diagram, an indispensable tool in database design. Students are tasked with crafting a visual representation that delineates the essential entities within the personal DVD library, defining their attributes and specifying the relationships that exist between them. This critical step bridges the theoretical concepts learned throughout the SEC4205 course with practical application, enabling students to conceptualize the structure of their database. Entities mapping is another pivotal phase of this assignment, wherein students translate the abstract entities outlined in the ER diagram into tangible database tables. This transformation is where theory meets practice, as students work to create structured tables that accurately represent the DVD library's data elements. Mapping entities to tables is a fundamental skill in database design, and this assignment provides students with the opportunity to apply this skill in a real-world context. Furthermore, students are guided in the development of a relational scheme, a vital component of any well-designed database system. The relational scheme establishes the relationships between the various tables and defines the keys that link them together. This aspect of the assignment underscores the importance of database integrity, as students learn how to maintain data consistency and coherence throughout the system. The creation of tables is also central to the assignment, with students tasked with defining the structure of these tables, specifying data types, and establishing relationships between them. This process mirrors the practical steps involved in constructing a functional database that can efficiently manage data related to the personal DVD library. Query design is another critical facet of this assignment. Students are encouraged to create meaningful and effective queries that align with the library's requirements. Through this exercise, students enhance their ability to retrieve and manipulate data, showcasing the practical relevance of a well-designed database system. Finally, the assignment culminates with the development of a user manual�a critical aspect of any professional database project. Students are challenged to document the database's structure, functionality, and usage guidelines in a clear and concise manner. Effective documentation is a hallmark of database professionalism, and students gain valuable experience in articulating complex technical information for end-users. In conclusion, the "HND SEC4205 Database Design and Development Assignment: Personal DVD Library" empowers HND students with practical skills in database design and development. Beyond theoretical knowledge, this assignment equips students to apply their expertise to real-world scenarios. The ability to create an ER diagram, map entities to tables, establish a relational scheme, design tables and queries, and document the system in a user manual is invaluable in the field of information technology and database management. As students complete this assignment, they not only fulfill the academic requirements of SEC4205 but also enhance their readiness to excel in the ever-evolving landscape of database design and development.

Introduction.. 2

Task 1. 2

ER DIAGRAM... 2

Task 2. 3

Step 1: Mapping of Regular Entities. 3

Step 2: Mapping of weak entities. 3

Step 3: Mapping of 1:M Relationships. 3

Step 4: Mapping of M:M Relationships. 4

Step 5: Mapping of Multivalued and Composite attributes. 4

Step 6: Mapping of N-Array Relationships. 4

Step 7: Mapping of ISA Relationships. 4

Finalized Relational Scheme. 5

Task 3. 6

1-Select Add database from database node. 6

2-input database name and press “ADD”. 6

3- Create table. 7

4- Insert data to table. 7

5- Delete data from table. 8

6- Update data from table. 8

7- Certificate table. 9

8- Producer table. 9

9- Actor table. 10

10- Actor Role table. 12

10- Actor Role table. 14

Task 4. 15

Queries. 15

Task 5. 17

Step 1. 17

Step 2. 17

Step 3. 17

Step 4. 18

Step 5. 18

Task 6. 20

What is a data base?    
... 20

What is a Query?. 20

Advantages of SQL. 20

Task 7. 22

Test case for table DVD Info. 22

Test case for table FIlM_CERT. 23

Test case for FIlM_PROD.. 24

Test case for FIlM_ACTOR. 25

Test case for  ACTOR_ROLE. 26

Test case for FILM_CATEG.. 27

Task 8. 28

User Manual 28

Task 9. 29

Validation. 29

Verification. 29

Task 10. 30

Open Sequel Pro and connect to the server. 30

Bibliography. 32

Introduction

In this assignment, the scenario relates to a personal DVD collection, for which I have to create and design a database, but first I’ll have to design an Entity Relationship diagram.

Task 1

ER DIAGRAM

Task 2

 Step 1: Mapping of Regular Entities

Step 2: Mapping of weak entities

Null

Step 3: Mapping of 1:M Relationships

Step 4: Mapping of M:M Relationships

Step 5: Mapping of Multivalued and Composite attributes

Null

Step 6: Mapping of N-Array Relationships

Null

Step 7: Mapping of ISA Relationships

Null

Finalized Relational Scheme

Task 3

1-Select Add database from database node.

2-input database name and press “ADD”.

3- Create table

Type the following commands to create a table

 Table view;

4- Insert data to table

Type the following commands to add data into the table

 Type the following commands to view the table

5- Delete data from table

Type the following commands to delete data from the table.

 You can see record number two deleted from the data base.

6- Update data from table

Type the following commands to delete data from the table.

You can see record number two updated from the data base.

7- Certificate table

8- Producer table

9- Actor table